Benchmarking Bitemporal Database Systems: Ready for the Future or Stuck in the Past?
نویسندگان
چکیده
After more than a decade of a virtual standstill, the adoption of temporal data management features has recently picked up speed, driven by customer demand and the inclusion of temporal expressions into SQL:2011. Most of the big commercial DBMS now include support for bitemporal data and operators. In this paper, we perform a thorough analysis of these commercial temporal DBMS: We investigate their architecture, determine their performance and study the impact of performance tuning. This analysis utilizes our recent (TPCTC 2013) benchmark proposal, which includes a comprehensive temporal workload definition. The results of our analysis show that the support for temporal data is still in its infancy: All systems store their data in regular, statically partitioned tables and rely on standard indexes as well as query rewrites for their operations. As shown by our measurements, this causes considerable performance variations on slight workload variations and significant overhead even after extensive tuning.
منابع مشابه
Applying Transition Rules to Bitemporal Deductive Databases for Integrity Constraint Checking
A bitemporal deductive database is a deductive database that supports valid and transaction time. A set of facts to be inserted and/or deleted in a bitemporal deductive database can be done in a past, present or future valid time. This circumstance causes that the maintenance of database consistency becomes more hard. In this paper, we present a new approach to reduce the difficulty of this pro...
متن کاملBenchmarking Sustainability with Respect to Transportation Supply and Demand
This paper is an endeavor to quantify the concept of sustainable transportation. The prevailing idea in the context of sustainable development (SD) emphasizes on the reduction of transportation demand in order to reduce the environmental and social consequences of it. Nevertheless, in the current paper using a measure for SD, and based on the conformity of the growths of all sectors with transp...
متن کاملThe Principles of Conservation-based Organization of Historic Paths Through Benchmarking Method on Organization Experience of Iran and Other Countries (Case Study: The Organization of a Historic Roadway and Pathway in Isfahan under Status Assessment)
Paths are the most important urban spaces and account for the city and its historic district’s main structure. In the past, the geometry of historic cities revolved around old bazar rows and passages. However, with the advent of motorized vehicles and subsequent chess roads in historical texture, organic geometry and hierarchy of paths net, integrity and structure of historic district were disr...
متن کاملBenchmarking Databases with History Support
An increasing number of applications such as risk evaluation in banking or inventory management require support for temporal data. After more than a decade of standstill, the recent adoption of some bitemporal features in SQL:2011 has reinvigorated the support among commercial database vendors, who incorporate an increasing number of relevant bitemporal features. Naturally, assessing the perfor...
متن کاملNEW APPLICATION FOR THE BITEMPORAL (VISOR) FLAP IN RECONSTRUCTION OF ADVANCED LOWER LIP CARCINOMA
Background: Lip carcinoma is a common cancer with a good prognosis and when patients refer early in the course of disease the results of treatment are acceptable. Surgical procedures for reconstruction of lip defects are the use of remaining lip tissue, tissue from the opposite lip, adjacent cheek tissue, distant flaps and microvascular free flaps. The bitemporal (visor) flap is a regional...
متن کامل